Previous Topic

Next Topic

Example: Find registered members by city

This query extracts Dallas individual members who registered for an event.

  1. Browse to IQA.
  2. Select Query from the drop-down list and select New.
  3. Select sources:
    1. Browse to the Common folder containing business objects.
    2. Select Contact and CsActivity.
  4. Define the filtering rules:
    1. Select the Filters tab.
    2. Select Mode: Advanced
    3. Operator: Where Not
    4. Filter on CsActivity.Activity Type.
      • Property: CsActivity.Activity Type
      • Comparison: Equal
      • Value: MEETING
    5. Add the filter.
    6. Select Add Filter.
    7. Select And from the drop-down list.
    8. Filter on Contact.City.
      • Property: Contact.City
      • Comparison: Equal
      • Value: DALLAS
    9. Add the filter.
    10. Filter on Contact.MemberType.
      • Property: Contact.MemberType
      • Comparison: Equal
      • Value: Individual Member
    11. Add the filter.
  5. Define the columns to display in the output:
    1. Select the Display tab.
    2. Select the following columns:
      • Contact.Id
      • Contact.City
      • Contact.MemberType
      • CsActivity.Activity Type

        Note: A default list of columns displays when you select the Display tab. Deselect the columns you do not need. If a column you need is not in the default list, select All from the View drop-down list and scroll down the page to select the desired column.

    3. Using the Order drop-down list, assign:
      • Contact.Id Order 1
      • Contact.City Order 2
      • Contact.MemberType Order 3
      • CsActivity.Activity Type Order 4
  6. Specify the sorting priority:
    1. Select the Sorting tab.
    2. Sort the results by ContactId.
    3. Add your selection.
  7. Save your settings.
  8. Run the query.

See Also

Query Examples

Example: Find recipients for e-mail

Example: Find current registrants

Example: Find members by company and state

Example: Find purchases by amount and date

Example: Find members by state or join date

Example: Find total number of pledges by amount


ASI logo 10.6 Production Release. Updated 7/27/2006 3:53:06 PM
© 2009 by Advanced Solutions International, Inc. All rights reserved.